Tablespace
Define a tablespace different from the default tablespace to create a table.
Logging
Specify whether creation of a database object will be logged in the redo log file (LOGGING) or not (NOLOGGING).
Parallel with degree
Specify the degree of parallelism, which is the number of parallel threads used in the parallel operation.
Key compress
Check this option to enable key compression. Upon necessary, you can also specify the prefix length (as the number of key columns), which identifies how the key columns are broken into a prefix and suffix entry.
Pct Threshold
When an overflow segment is being used, it defines the maximum size of the portion of the row that is stored in the index block, as a percentage of block size.
Mapping table
Check to specify a mapping table for the index-organized table. Note that a mapping table is required for creating bitmap indexes on an index-organized table.
Physical Attributes
Refer to Editing Physical Attributes/Default Storage Characteristics.
IOT Overflow
Overflow
Check to enable an overflow storage area.Note: After saving the table, this option cannot be unchecked.
Last Index Column
Specify the column to be put in a separate overflow data segment.Tablespace
Specify the tablespace in which the overflow segment to be stored.Logging
Specify whether creation of a database object will be logged in the redo log file (LOGGING) or not (NOLOGGING).Physical Attributes
Refer to Editing Physical Attributes/Default Storage Characteristics.